#!/usr/local/bin/perl -w

use App::Options (
    options => [qw(dbdriver dbclass dbhost dbname dbuser dbpass)],
    option => {
        dbclass  => { default => "App::Repository::MySQL", },
        dbdriver => { default => "mysql", },
        dbhost   => { default => "localhost", },
        dbname   => { default => "test", },
        dbuser   => { default => "", },
        dbpass   => { default => "", },
        log_level => { default => 0, },
    },
);

use Test::More qw(no_plan);
use lib "../App-Context/lib";
use lib "../../App-Context/lib";
use lib "../App-Repository/lib";
use lib "../../App-Repository/lib";
use lib "lib";
use lib "../lib";

use App;
use App::Repository;
use strict;

my $t_dir = (-d "t") ? "t" : ".";

use App::WorkQueue::Repository;

if (! -f "$t_dir/app.conf") {
    ok(1, "No dbuser given. Tests assumed OK. (add dbname=abc, dbuser=xxx, and dbpass=yyy to app.conf in 't' directory)");
    exit(0);
}

my $context = App->context(
    conf_file => "",
    conf => {
        Repository => {
            default => {
                class => $App::options{dbclass},
                dbdriver => $App::options{dbdriver},
                dbhost => $App::options{dbhost},
                dbname => $App::options{dbname},
                dbuser => $App::options{dbuser},
                dbpass => $App::options{dbpass},
                #table => {
                #    test_person => {
                #        primary_key => ["person_id"],
                #    },
                #},
            },
        },
        SessionObject => {
            foo => {
                class => "Foo",
            },
        },
    },
    context_class => "App::Context::ClusterController",
    debug_sql => $App::options{debug_sql},
    log_level => $App::options{log_level},
);

{
    my $db = $context->repository();
    #cheating... I know its a DBI, but I have to set up the test somehow
    my $dbh     = $db->{dbh};
    eval { $dbh->do("drop table t_hotel_subrequest"); };
    my $ddl     = <<EOF;
create table t_hotel_subrequest (
    subrequest_id          integer       not null auto_increment primary key,
    shop_request_id        integer       not null,
    org_id                 integer       not null,

    prop_id                integer       not null,
    shop_data_source       varchar(255)  not null,
    shop_currency_cd       varchar(3)    not null,
    shop_pos_cd            varchar(255)  not null,
    los                    integer       not null,
    guests                 integer       not null,
    begin_arv_dt           date          not null,
    end_arv_dt             date          not null,
    dow                    varchar(13)   null,
    comp_id                varchar(255)  null,

    scheduled_dttm         datetime      null,
    start_dttm             datetime      null,
    complete_dttm          datetime      null,
    change_dttm            datetime      null,
    request_status         char(1)       null,
    client_userid          varchar(99)   null,
    client_system_cd       varchar(5)    null,
    server_system_cd       varchar(5)    null,
    work_units             integer       null,
    work_units_complete    integer       null,
    work_units_error       integer       not null default 0,
    work_units_blank       integer       not null default 0,
    work_units_skipped     integer       not null default 0,
    request_msg            varchar(255)  null,
    email_notify           varchar(255)  null,
    email_type             varchar(24)   null,
    shop_units             integer       null,
    profile                varchar(255)  null,

    display_option         varchar(99)   null,
    view_data_sources      varchar(255)  null,
    date_sense             varchar(5)    null,
    comp_prod_id           varchar(255)  null,
    rm_type                varchar(12)   null,
    accom                  varchar(16)   null,
    prev_day_compare       varchar(10)   null,
    compare_options        varchar(24)   null,
    cell_drilldown         varchar(5)    null,
    highlight_ind          varchar(3)    null,
    rate_details           varchar(20)   null,
    shop_data_age          varchar(10)   null,

    shop_host              varchar(32)   null,
    shop_priority          integer       not null default 2,
    shop_fresh_mins        integer       not null default 1080,
    file_output_ind        char(1)       null,
    override_data_source   char(3)       default NULL,
    comp_strat_cd          varchar(16)   not null default 'none',
    mkt_keyword            varchar(255)  null, -- or "city_nm, state_cd, US" or "city_nm, country_cd"
    shop_level             integer       null, -- number of pages deep to go in a mkt shop

    finish_in_subprocess   varchar(3)    null,
    actual_data_source     varchar(11)   null,
    report_units           integer       not null default 0,

    group_data_source      varchar(11)   null,
    q_client_id            varchar(32)   null,
    est_cpu_util_pct       integer       null,
    est_mem_mb             integer       null,
    cpu_time_ms            integer       null,
    run_time_ms            integer       null,
    start_mem_mb           integer       null,
    end_mem_mb             integer       null,

    unique hotel_subrequest_ak1 (shop_request_id, comp_id, begin_arv_dt, shop_data_source, los, email_type),
    index hotel_subrequest_ie2  (request_status, email_type),
    index hotel_subrequest_ie3  (request_status, change_dttm),
    index hotel_subrequest_ie4  (request_status, group_data_source, actual_data_source, comp_id, complete_dttm),
    index hotel_subrequest_ie5  (shop_request_id, request_status)
) TYPE=InnoDB
EOF
    $dbh->do($ddl);
}

{
    &run("hotel_subrequest");
    #&run("hotel_subrequest2", 1);
}

sub run {
    my ($qname, $rerun) = @_;
    my $db = $context->repository();
    my $table = "t_hotel_subrequest";

    my ($errmsg, %colidx);
    #my $columns = [qw(
    #    shop_request_id
    #    org_id prop_id shop_data_source
    #    shop_currency_cd shop_pos_cd los guests
    #    begin_arv_dt end_arv_dt dow comp_id comp_prod_id
    #    scheduled_dttm start_dttm complete_dttm change_dttm
    #    request_status client_userid client_system_cd server_system_cd
    #    work_units work_units_complete
    #    request_msg email_notify email_type shop_units profile
    #    work_units_error work_units_blank shop_host shop_priority shop_fresh_mins
    #    actual_data_source file_output_ind work_units_skipped override_data_source
    #    display_option prev_day_compare mkt_keyword shop_level
    #)];
    #for (my $i = 0; $i <= $#$columns; $i++) {
    #    $colidx{$columns->[$i]} = $i;
    #}
    my %state = (
        num_reports => 0,
        max_reports => 8,
    );

    my $q = $context->work_queue($qname,
        queue_type        => "HASH",
        class             => "App::WorkQueue::Repository",
        table             => $table,
        id_attrib         => "shop_request_id,comp_id,begin_arv_dt,shop_data_source,los",
        auto_id_attrib    => "subrequest_id",
        status_attrib     => "request_status",
        sort_spec         => "N-shop_priority,N+shop_request_id,subrequest_id",
        client_id_attrib  => "q_client_id",
        client_id         => "$App::options{host}:$qname",
        STATUS_UNBUFFERED => "W",
        STATUS_UNACQUIRED => "W",
        STATUS_ACQUIRED   => "R",
        STATUS_RELEASED   => "S",
        BUFFER_SIZE       => 20,
        params            => {
            email_type => "SugOnly,ReportOnly,FileOnly,NotifyOnly,FileNotify,ReportFile",
        },
    );
    isa_ok($q, "App::WorkQueue");
    isa_ok($q, "App::WorkQueue::Repository");

    my (%num_workers_ds, %max_workers_ds);
    $max_workers_ds{EXP} = 5;

    eval {
        $q->set_global_constraint(\%state, \%state, "num_reports", "max_reports");
        ok(1, "set_global_constraint(...)");
        $q->set_constraint(\%num_workers_ds, \%max_workers_ds, "shop_data_source");
        ok(1, "set_constraint(shop_data_source)");
    };
    ok(!$@, "No errors [$@]");

    &load_test_data($db, $q);

    &test_status_counts($q, 0, 42, 0, 0);
    &test_resource_buffer_counts($q, "EXP", 20, 42);

    my ($e, @e, $e1, $e2, $e3, $e4);

    $e1 = $q->acquire();
    #$q->print();
    &test_status_counts($q, 0, 41, 1, 0);
    &test_resource_buffer_counts($q, "EXP", 39, 41);

    $e2 = $q->acquire();
    #$q->print();
    &test_status_counts($q, 0, 40, 2, 0);
    &test_resource_buffer_counts($q, "EXP", 38, 40);

    $e3 = $q->acquire();
    #$q->print();
    &test_status_counts($q, 0, 39, 3, 0);
    &test_resource_buffer_counts($q, "EXP", 37, 39);

    $e4 = $q->acquire();
    #$q->print();
    &test_status_counts($q, 0, 38, 4, 0);
    &test_resource_buffer_counts($q, "EXP", 36, 38);

    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);
    #$q->print();
    &test_status_counts($q, 0, 38, 0, 4);
    &test_resource_buffer_counts($q, "EXP", 36, 38);

    $e1 = $q->acquire(); &test_status_counts($q, 0, 37, 1, 4); &test_resource_buffer_counts($q, "EXP", 35, 37);
    $e2 = $q->acquire(); &test_status_counts($q, 0, 36, 2, 4); &test_resource_buffer_counts($q, "EXP", 34, 36);
    $e3 = $q->acquire(); &test_status_counts($q, 0, 35, 3, 4); &test_resource_buffer_counts($q, "EXP", 33, 35);
    $e4 = $q->acquire(); &test_status_counts($q, 0, 34, 4, 4); &test_resource_buffer_counts($q, "EXP", 32, 34);
    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);    &test_status_counts($q, 0, 34, 0, 8); &test_resource_buffer_counts($q, "EXP", 32, 34);

    $e1 = $q->acquire(); &test_status_counts($q, 0, 33, 1, 8); &test_resource_buffer_counts($q, "EXP", 31, 33);
    $e2 = $q->acquire(); &test_status_counts($q, 0, 32, 2, 8); &test_resource_buffer_counts($q, "EXP", 30, 32);
    $e3 = $q->acquire(); &test_status_counts($q, 0, 31, 3, 8); &test_resource_buffer_counts($q, "EXP", 29, 31);
    $e4 = $q->acquire(); &test_status_counts($q, 0, 30, 4, 8); &test_resource_buffer_counts($q, "EXP", 28, 30);
    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);    &test_status_counts($q, 0, 30, 0,12); &test_resource_buffer_counts($q, "EXP", 28, 30); 

    $e1 = $q->acquire(); &test_status_counts($q, 0, 29, 1,12); &test_resource_buffer_counts($q, "EXP", 27, 29);
    $e2 = $q->acquire(); &test_status_counts($q, 0, 28, 2,12); &test_resource_buffer_counts($q, "EXP", 26, 28);
    $e3 = $q->acquire(); &test_status_counts($q, 0, 27, 3,12); &test_resource_buffer_counts($q, "EXP", 25, 27);
    $e4 = $q->acquire(); &test_status_counts($q, 0, 26, 4,12); &test_resource_buffer_counts($q, "EXP", 24, 26);
    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);    &test_status_counts($q, 0, 26, 0,16); &test_resource_buffer_counts($q, "EXP", 24, 26);

    $e1 = $q->acquire(); &test_status_counts($q, 0, 25, 1,16); &test_resource_buffer_counts($q, "EXP", 23, 25);
    $e2 = $q->acquire(); &test_status_counts($q, 0, 24, 2,16); &test_resource_buffer_counts($q, "EXP", 22, 24);
    $e3 = $q->acquire(); &test_status_counts($q, 0, 23, 3,16); &test_resource_buffer_counts($q, "EXP", 21, 23);
    $e4 = $q->acquire(); &test_status_counts($q, 0, 22, 4,16); &test_resource_buffer_counts($q, "EXP", 20, 22);
    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);    &test_status_counts($q, 0, 22, 0,20); &test_resource_buffer_counts($q, "EXP", 20, 22);

    $e1 = $q->acquire(); &test_status_counts($q, 0, 21, 1,20); &test_resource_buffer_counts($q, "EXP", 21, 21);
    $e2 = $q->acquire(); &test_status_counts($q, 0, 20, 2,20); &test_resource_buffer_counts($q, "EXP", 20, 20);
    $e3 = $q->acquire(); &test_status_counts($q, 0, 19, 3,20); &test_resource_buffer_counts($q, "EXP", 19, 19);
    $e4 = $q->acquire(); &test_status_counts($q, 0, 18, 4,20); &test_resource_buffer_counts($q, "EXP", 18, 18);
    $q->release($e1);
    $q->release($e2);
    $q->release($e3);
    $q->release($e4);    &test_status_counts($q, 0, 18, 0,24); &test_resource_buffer_counts($q, "EXP", 18, 18);

    exit(0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 40, 2, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 39, 3, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 38, 4, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 37, 5, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 36, 6, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 35, 7, 0);
    $e = $q->acquire();
    &test_status_counts($q, 0, 34, 8, 0);
    $e = $q->acquire();
    is($e, undef, "throttle full");
    &test_status_counts($q, 0, 34, 8, 0);
}

sub test_status_counts {
    my ($q, $N_count, $W_count, $R_count, $S_count) = @_;
    my ($count);
    if (defined $N_count) {
        $count = $q->num_entries("N");
        is($count, $N_count, "N count is $N_count");
    }
    if (defined $W_count) {
        $count = $q->num_entries("W");
        is($count, $W_count, "W count is $W_count");
    }
    if (defined $R_count) {
        $count = $q->num_entries("R");
        is($count, $R_count, "R count is $R_count");
    }
    if (defined $S_count) {
        $count = $q->num_entries("S");
        is($count, $S_count, "S count is $S_count");
    }
}

sub test_resource_buffer_counts {
    my ($q, $resource_key, $buffer, $total) = @_;
    my $resource_counts = $q->_resource_counts();
    is($resource_counts->{buffer}{$resource_key}||0, $buffer, "$resource_key buffer count is $buffer");
    is($resource_counts->{total}{$resource_key}||0, $total, "$resource_key total count is $total");
}

sub load_test_data {
    my ($db, $q) = @_;
    my $table = "t_hotel_subrequest";
    #$db->delete($table,{});
    my $data = &data();
    foreach my $row (@$data) {
        $row->{subrequest_id} = undef;
        $row->{request_status} = "W";
        $row->{q_client_id} = undef;
        #$db->insert($table, $row);
        $q->push($row);
        #$q->print();
    }
}

sub data {
    my $VAR1 = [
          {
            'profile' => 'RT03: Reports compare.arv_dt.html',
            'cpu_time_ms' => '820',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:00:59',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48416',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5702',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '7311',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:46',
            'display_option' => 'compare.arv_dt.html',
            'start_mem_mb' => '38912',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '891',
            'change_dttm' => '2006-06-03 19:01:46',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.car_type_cd.html',
            'cpu_time_ms' => '630',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '47856',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-09',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:40',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5703',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '3270',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:42',
            'display_option' => 'compare.car_type_cd.html',
            'start_mem_mb' => '38924',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '892',
            'change_dttm' => '2006-06-03 19:01:42',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.arv_dt_car_type.html',
            'cpu_time_ms' => '650',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '47816',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-09',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5704',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '5526',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:44',
            'display_option' => 'compare.arv_dt_car_type.html',
            'start_mem_mb' => '38920',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '893',
            'change_dttm' => '2006-06-03 19:01:44',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports detail',
            'cpu_time_ms' => '570',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '47620',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-03',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5705',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2733',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:41',
            'display_option' => 'detail',
            'start_mem_mb' => '38924',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '894',
            'change_dttm' => '2006-06-03 19:01:41',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports detail.ALLRATES',
            'cpu_time_ms' => '610',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '47628',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-03',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5706',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '3394',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:42',
            'display_option' => 'detail.ALLRATES',
            'start_mem_mb' => '38924',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '895',
            'change_dttm' => '2006-06-03 19:01:42',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.arv_dt.pdf',
            'cpu_time_ms' => '740',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48300',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:40',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5707',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4506',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:43',
            'display_option' => 'compare.arv_dt.pdf',
            'start_mem_mb' => '38924',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '896',
            'change_dttm' => '2006-06-03 19:01:43',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.car_type_cd.pdf',
            'cpu_time_ms' => '690',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '47784',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-09',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5708',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '3574',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:42',
            'display_option' => 'compare.car_type_cd.pdf',
            'start_mem_mb' => '38928',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '897',
            'change_dttm' => '2006-06-03 19:01:42',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.arv_dt.csv',
            'cpu_time_ms' => '820',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48280',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:40',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5709',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4457',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:43',
            'display_option' => 'compare.arv_dt.csv',
            'start_mem_mb' => '38928',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '898',
            'change_dttm' => '2006-06-03 19:01:43',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.product.html',
            'cpu_time_ms' => '830',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48524',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5710',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4979',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:44',
            'display_option' => 'compare.product.html',
            'start_mem_mb' => '38932',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '899',
            'change_dttm' => '2006-06-03 19:01:44',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.los.html',
            'cpu_time_ms' => '770',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48452',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5711',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '3903',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:43',
            'display_option' => 'compare.ckey.los.html',
            'start_mem_mb' => '38932',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '900',
            'change_dttm' => '2006-06-03 19:01:43',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.html',
            'cpu_time_ms' => '2900',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57728',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5712',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '8434',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:47',
            'display_option' => 'compare.ckey.data_source.html',
            'start_mem_mb' => '38932',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '901',
            'change_dttm' => '2006-06-03 19:01:47',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.comparison.html',
            'cpu_time_ms' => '3080',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57732',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:39',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5713',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '14293',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:53',
            'display_option' => 'compare.ckey.data_source.comparison.html',
            'start_mem_mb' => '38936',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '902',
            'change_dttm' => '2006-06-03 19:01:53',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.comparison.pdf',
            'cpu_time_ms' => '3170',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57184',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:40',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5714',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '13268',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:53',
            'display_option' => 'compare.ckey.data_source.comparison.pdf',
            'start_mem_mb' => '38940',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '903',
            'change_dttm' => '2006-06-03 19:01:53',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.comparison.xls',
            'cpu_time_ms' => '3760',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '59372',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5715',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '23679',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:03',
            'display_option' => 'compare.ckey.data_source.comparison.xls',
            'start_mem_mb' => '38940',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '904',
            'change_dttm' => '2006-06-03 19:02:03',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source_los.html',
            'cpu_time_ms' => '2590',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57196',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:43',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5716',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '17584',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:00',
            'display_option' => 'compare.ckey.data_source_los.html',
            'start_mem_mb' => '38944',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '905',
            'change_dttm' => '2006-06-03 19:02:00',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source_los.xls',
            'cpu_time_ms' => '2610',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57180',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:43',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5717',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  /usr/rubicon/test/htdocs/temp/20060603-190143-32178-1.xls: not readable
',
            'run_time_ms' => '18472',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:01',
            'display_option' => 'compare.ckey.data_source_los.xls',
            'start_mem_mb' => '38940',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '906',
            'change_dttm' => '2006-06-03 19:02:01',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_product.html',
            'cpu_time_ms' => '760',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48472',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:43',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5718',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4947',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:47',
            'display_option' => 'compare.mkt.arv_dt_product.html',
            'start_mem_mb' => '38952',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '907',
            'change_dttm' => '2006-06-03 19:01:47',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_los.html',
            'cpu_time_ms' => '750',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48464',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:43',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5719',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4450',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:47',
            'display_option' => 'compare.mkt.arv_dt_los.html',
            'start_mem_mb' => '38940',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '908',
            'change_dttm' => '2006-06-03 19:01:47',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_data_source.html',
            'cpu_time_ms' => '3100',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57760',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:45',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5720',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '7722',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:52',
            'display_option' => 'compare.mkt.arv_dt_data_source.html',
            'start_mem_mb' => '38952',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '909',
            'change_dttm' => '2006-06-03 19:01:52',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_product.xls',
            'cpu_time_ms' => '910',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '50948',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:45',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5721',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
	(in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
            'run_time_ms' => '2356',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:46',
            'display_option' => 'compare.mkt.arv_dt_product.xls',
            'start_mem_mb' => '38940',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '910',
            'change_dttm' => '2006-06-03 19:01:46',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_los.xls',
            'cpu_time_ms' => '880',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '50968',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:47',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5722',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
	(in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
            'run_time_ms' => '2520',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:49',
            'display_option' => 'compare.mkt.arv_dt_los.xls',
            'start_mem_mb' => '38952',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '911',
            'change_dttm' => '2006-06-03 19:01:49',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.mkt.arv_dt_data_source.xls',
            'cpu_time_ms' => '2890',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '59068',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:44',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5723',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
	(in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
            'run_time_ms' => '5068',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:49',
            'display_option' => 'compare.mkt.arv_dt_data_source.xls',
            'start_mem_mb' => '38952',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '912',
            'change_dttm' => '2006-06-03 19:01:49',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.parity.xls',
            'cpu_time_ms' => '9880',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '79028',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:45',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5724',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '21775',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:06',
            'display_option' => 'compare.parity.xls',
            'start_mem_mb' => '38944',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '913',
            'change_dttm' => '2006-06-03 19:02:06',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.history.html',
            'cpu_time_ms' => '9410',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '54380',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:48',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5725',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '18558',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:06',
            'display_option' => 'compare.history.html',
            'start_mem_mb' => '38944',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '914',
            'change_dttm' => '2006-06-03 19:02:06',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.history.csv',
            'cpu_time_ms' => '7430',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '52188',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:48',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5726',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '18698',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:06',
            'display_option' => 'compare.history.csv',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '915',
            'change_dttm' => '2006-06-03 19:02:06',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.history.xml',
            'cpu_time_ms' => '4230',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '52572',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:50',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5727',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '12776',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:02',
            'display_option' => 'compare.history.xml',
            'start_mem_mb' => '38944',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '916',
            'change_dttm' => '2006-06-03 19:02:02',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.history.xls',
            'cpu_time_ms' => '8480',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '61540',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:50',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5728',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  Maximum Spreadsheet::WriteExcel filesize, 7087104 bytes, exceeded. To create files bigger than this limit please refer to the "Spreadsheet::WriteExcel::Big" documentation.
 at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView/XLS.pm line 164
',
            'run_time_ms' => '19254',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:09',
            'display_option' => 'compare.history.xls',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '917',
            'change_dttm' => '2006-06-03 19:02:09',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.history.pdf',
            'cpu_time_ms' => '7750',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '52472',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:52',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5729',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '19612',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:11',
            'display_option' => 'compare.history.pdf',
            'start_mem_mb' => '38944',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '918',
            'change_dttm' => '2006-06-03 19:02:11',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.product.pdf',
            'cpu_time_ms' => '750',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48332',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:53',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5730',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '1931',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:55',
            'display_option' => 'compare.product.pdf',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '919',
            'change_dttm' => '2006-06-03 19:01:55',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.los.pdf',
            'cpu_time_ms' => '780',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48324',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:55',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5731',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2061',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:01:57',
            'display_option' => 'compare.ckey.los.pdf',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '920',
            'change_dttm' => '2006-06-03 19:01:57',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.pdf',
            'cpu_time_ms' => '2880',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57176',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:01:57',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5732',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '7720',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:04',
            'display_option' => 'compare.ckey.data_source.pdf',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '921',
            'change_dttm' => '2006-06-03 19:02:04',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.arv_dt.xls',
            'cpu_time_ms' => '1110',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '51256',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:00',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5733',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2729',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:02',
            'display_option' => 'compare.arv_dt.xls',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '922',
            'change_dttm' => '2006-06-03 19:02:02',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.product.xls',
            'cpu_time_ms' => '1260',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '51396',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:02',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5734',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '8209',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:10',
            'display_option' => 'compare.product.xls',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '923',
            'change_dttm' => '2006-06-03 19:02:10',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.los.xls',
            'cpu_time_ms' => '1080',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '51252',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:03',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5735',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2752',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:05',
            'display_option' => 'compare.ckey.los.xls',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '924',
            'change_dttm' => '2006-06-03 19:02:05',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.ckey.data_source.xls',
            'cpu_time_ms' => '2870',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '59348',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5736',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4016',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:45',
            'display_option' => 'compare.ckey.data_source.xls',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '925',
            'change_dttm' => '2006-06-03 19:02:45',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.los.csv',
            'cpu_time_ms' => '800',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48272',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5737',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2161',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:43',
            'display_option' => 'compare.los.csv',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '926',
            'change_dttm' => '2006-06-03 19:02:43',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.data_source.csv',
            'cpu_time_ms' => '2450',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57164',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5738',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4022',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:45',
            'display_option' => 'compare.data_source.csv',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '927',
            'change_dttm' => '2006-06-03 19:02:45',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.arv_dt.all.csv',
            'cpu_time_ms' => '870',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48280',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5739',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '2239',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:43',
            'display_option' => 'compare.arv_dt.all.csv',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '928',
            'change_dttm' => '2006-06-03 19:02:43',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.data_source.los.csv',
            'cpu_time_ms' => '2210',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '57172',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:42',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5740',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '4409',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:46',
            'display_option' => 'compare.data_source.los.csv',
            'start_mem_mb' => '38956',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '929',
            'change_dttm' => '2006-06-03 19:02:46',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.text',
            'cpu_time_ms' => '680',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48208',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-03 19:02:41',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5741',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => 'ERROR:  Can\'t call method "_render_3d_basic" on an undefined value at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateSet.pm line 557.
',
            'run_time_ms' => '1118',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-03 19:02:42',
            'display_option' => 'compare.text',
            'start_mem_mb' => '38948',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '930',
            'change_dttm' => '2006-06-03 19:02:42',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.xml',
            'cpu_time_ms' => '480',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48464',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-05 11:25:56',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5742',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '18031',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-05 11:26:13',
            'display_option' => 'compare.xml',
            'start_mem_mb' => '38924',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '931',
            'change_dttm' => '2006-06-05 11:26:13',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          },
          {
            'profile' => 'RT03: Reports compare.all.xml',
            'cpu_time_ms' => '520',
            'group_data_source' => undef,
            'shop_data_age' => '7',
            'file_output_ind' => undef,
            'work_units_skipped' => '0',
            'scheduled_dttm' => '2006-06-03 19:01:00',
            'shop_level' => '10',
            'shop_host' => undef,
            'comp_strat_cd' => 'none',
            'work_units_error' => '0',
            'shop_fresh_mins' => '1080',
            'end_mem_mb' => '48628',
            'client_system_cd' => 'MV',
            'override_data_source' => undef,
            'end_arv_dt' => '2006-06-18',
            'prop_id' => '128',
            'work_units_complete' => '0',
            'client_userid' => 'spadkins',
            'finish_in_subprocess' => undef,
            'cell_drilldown' => 'Y',
            'start_dttm' => '2006-06-05 11:25:56',
            'begin_arv_dt' => '2006-06-03',
            'rm_type' => '',
            'est_cpu_util_pct' => undef,
            'shop_priority' => '1',
            'shop_request_id' => '5743',
            'shop_units' => '0',
            'server_system_cd' => 'MV',
            'compare_options' => 'PrevRateAndDirection',
            'view_data_sources' => 'EXP',
            'shop_data_source' => 'EXP',
            'work_units_blank' => '0',
            'prev_day_compare' => 'None',
            'request_msg' => '',
            'run_time_ms' => '7773',
            'dow' => '1,2,3,4,5,6,7',
            'q_client_id' => 'frento:q-hotel_compute',
            'complete_dttm' => '2006-06-05 11:26:03',
            'display_option' => 'compare.all.xml',
            'start_mem_mb' => '38928',
            'mkt_keyword' => '',
            'actual_data_source' => undef,
            'rate_details' => 'Rate',
            'comp_prod_id' => '1',
            'email_notify' => 'sadkins@therubicongroup.com',
            'highlight_ind' => 'Y',
            'date_sense' => 'Auto',
            'org_id' => '1',
            'report_units' => '0',
            'email_type' => 'ReportOnly',
            'los' => '1',
            'guests' => '1',
            'shop_currency_cd' => 'USD',
            'subrequest_id' => '932',
            'change_dttm' => '2006-06-05 11:26:03',
            'request_status' => 'W',
            'comp_id' => '132,128,133,129,130',
            'est_mem_mb' => undef,
            'accom' => '',
            'shop_pos_cd' => 'US',
            'work_units' => '0'
          }
        ];
    return($VAR1);
}

